UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9N+UUxK/KkA1CYnWNuq0sX0doD36DT7Ulru6eboMgxg='
WHERE
key_id = 'f5a70e5f5f727c05823c409ec58013ebd9255388f568e1cce369fd4f4192f32a'
AND (
token = '9N+UUxK/KkA1CYnWNuq0sX0doD36DT7Ulru6eboMgxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)