UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UbDMhzdK/0BQAEeqW0MX1Wlf+0kPkiycUWv29JIKl3E='
WHERE
key_id = 'f729def6071c70f4f0c724de1671444fb89238608e5108be456d73a57f093a59'
AND (
token = 'UbDMhzdK/0BQAEeqW0MX1Wlf+0kPkiycUWv29JIKl3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)