UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LvgeGw+BXlRYBLOjZvs+ZRX97C7jWyPYoe1wTHjvswI='
WHERE
key_id = '4fa9acd4e827a1f240c1ba7aeeca380cf4a3840b677220cae0f4c100a837803a'
AND (
token = 'LvgeGw+BXlRYBLOjZvs+ZRX97C7jWyPYoe1wTHjvswI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)