UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sOSp1wY6wrtNowkLFrCBLFmPO4gxcmapMl6JvfkmeEc='
WHERE
key_id = '504c14b813245471de21dca315901333810fa8d3fc739978ddcb32621da726c8'
AND (
token = 'sOSp1wY6wrtNowkLFrCBLFmPO4gxcmapMl6JvfkmeEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)