UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZY1JIvV3+MDU8TwkGRwnFwaTxHWeVBNCV31gVSNQco='
WHERE
key_id = '78793b3b7b2bb06fbe209527bbe0baa4585e1f49004d41503885a6180d9fa936'
AND (
token = 'gZY1JIvV3+MDU8TwkGRwnFwaTxHWeVBNCV31gVSNQco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)