UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tC8OIGwxuglm4wiaxcdQvmq/v3yJC+lOTK0NJfRLUJ8='
WHERE
key_id = '7e7a413c949dd8d5e01fe94e1a309d316ed13d87883117e57588a0c5080339c9'
AND (
token = 'tC8OIGwxuglm4wiaxcdQvmq/v3yJC+lOTK0NJfRLUJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)