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