UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGzNZKslhyOKNC7+fbUrsXWxeRlvznCSL3vG1Rcl8ZA='
WHERE
key_id = 'fd23311389c80f3d922db265548e65d6af982ab21e0c5ea7a26a4368a296eeb3'
AND (
token = 'CGzNZKslhyOKNC7+fbUrsXWxeRlvznCSL3vG1Rcl8ZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)