UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Phg9tCJTpSel8oVKOS5doEn8GbnplER6PV5fvvvOXL4='
WHERE
key_id = '3257ccaad55ab79486fc586d1a9048be45de3747cf6fcad6234687ad7bd4f55f'
AND (
token = 'Phg9tCJTpSel8oVKOS5doEn8GbnplER6PV5fvvvOXL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)