UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHEjQZmWNLo6UqidlWnmch3RkX7fTvki9KMS5tl8F/k='
WHERE
key_id = '8b86081a0cae33321ada21fe3f9bf403dd9b73abc4f88d41a45561370cd46c18'
AND (
token = 'zHEjQZmWNLo6UqidlWnmch3RkX7fTvki9KMS5tl8F/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)