UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gskXXaU6vANUf3RyDdizvZpP1l0yfpRK1kYlRtuoHog='
WHERE
key_id = '0bc0f54a963a3edfd9bf0776f7b7725ffcd0b16c4f4773983b25e7437a891934'
AND (
token = 'gskXXaU6vANUf3RyDdizvZpP1l0yfpRK1kYlRtuoHog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)