UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FfZtZPSzZ6kxv30DfdV3d5ZBIcubP5KnT3KVfRAiKUw='
WHERE
key_id = '1c622de585ac7b4e113259710a6cbb0d6cfbe4100da189251ad164ad50d7140b'
AND (
token = 'FfZtZPSzZ6kxv30DfdV3d5ZBIcubP5KnT3KVfRAiKUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)