UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vms/E79uPew8VadZvDmkYkofy8SjE0MY5EcMc/tFM8Y='
WHERE
key_id = '47e90804a5309bc4c02282b57945f35b759e40744b3d8c699030156654502bcf'
AND (
token = 'Vms/E79uPew8VadZvDmkYkofy8SjE0MY5EcMc/tFM8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)