UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NlXE60JSJxWzUGp+oplh2J2EgspYikOxphhiYDPnVrs='
WHERE
key_id = '9f0359e34ff2b8be332c0684ae52ca9caf6e4b5ee39cd0b8c47be396b162cad4'
AND (
token = 'NlXE60JSJxWzUGp+oplh2J2EgspYikOxphhiYDPnVrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)