UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2jZRm4NYwgqVfuuynABeh0vWVnD/Ut1wNUvym7nhnb4='
WHERE
key_id = 'c3f6855746ba36414b4a40487637815517db959bb5840d7a8621d2fc02e39d90'
AND (
token = '2jZRm4NYwgqVfuuynABeh0vWVnD/Ut1wNUvym7nhnb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)