UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K/PtNviYUjPkpn/Jxh5TV6+lUc+D7xJ9GG3/dpMz8hI='
WHERE
key_id = '166edb9be07ccc327d892c888c0ac8bc3fe4679696c5f2de107baccd42a0ce32'
AND (
token = 'K/PtNviYUjPkpn/Jxh5TV6+lUc+D7xJ9GG3/dpMz8hI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)