UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gYO1VzCokLnJOSc0WXmO8fhNx+U63L17LJGmAXnJpzk='
WHERE
key_id = 'e60b709b75d7f5c2eca9e6425f87cf16bb7c4eff1cde8ad41ac9e541e23dd8de'
AND (
token = 'gYO1VzCokLnJOSc0WXmO8fhNx+U63L17LJGmAXnJpzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)