UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0hvcI8MWAc672KfDAn8OEjosKJZvbPfmpGDeRDQsCaU='
WHERE
key_id = '8b24434c31bb2420fe1238b17d8be52c0781fa6f7117797aa4e79d1a40e9826f'
AND (
token = '0hvcI8MWAc672KfDAn8OEjosKJZvbPfmpGDeRDQsCaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)