UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ZHm+T5x06d7uXPIs/YbyGQ3aS1xvMqCVLG52qukwg0='
WHERE
key_id = '4fb4e9f996eabad686e5565764eed8cb3e3760fe1565fa922db7be31e23616ec'
AND (
token = '6ZHm+T5x06d7uXPIs/YbyGQ3aS1xvMqCVLG52qukwg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)