UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/xE6lg9iANQXkYyM1S/zcFGWuOQZSi3WW869Dl2mc5g='
WHERE
key_id = 'e8216bfd2d7f28d5100f9ad7bebad7c740b7f5a606a6da96312de3f850f40062'
AND (
token = '/xE6lg9iANQXkYyM1S/zcFGWuOQZSi3WW869Dl2mc5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)