UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJ9vFIcOsVVB3K1kGIo1yHejEn0SnpCawFR9WyhNJKE='
WHERE
key_id = '112ca4f227446ce37ba644d5543472718bcf459f78703ccd5758087f46e698a3'
AND (
token = 'ZJ9vFIcOsVVB3K1kGIo1yHejEn0SnpCawFR9WyhNJKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)