UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QW/8lf4zHqmP/dZZIlYwwSAO0l45/SEwxcjAEaQc7j0='
WHERE
key_id = 'a27eb033c3df526d5b4cc920a06aa6996c2e3589f5bf11b444ee463a99071fe9'
AND (
token = 'QW/8lf4zHqmP/dZZIlYwwSAO0l45/SEwxcjAEaQc7j0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)