UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aNKcBW4SGBEc5TDubWEhYTJxf+86N/RkNSU1dJEOWPc='
WHERE
key_id = '8ffd7e21b870f8eefa9d86f5f7b489616b49b866f3d0d57931a7c17b0209574b'
AND (
token = 'aNKcBW4SGBEc5TDubWEhYTJxf+86N/RkNSU1dJEOWPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)