UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Bm2jNtlTC0mA5BL6ArrPalfHNdT9xS9vGQcEAcrzTM='
WHERE
key_id = 'ce96819681c74ac62bf19b47a026195541ca0a5928c585e8befab29eddd60b4e'
AND (
token = '4Bm2jNtlTC0mA5BL6ArrPalfHNdT9xS9vGQcEAcrzTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)