UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nCoSSDH/0MuV5lW6ekO94tgNmmU4BkV3ymaqwbaa/74='
WHERE
key_id = '686cf3de9fa8adddbf4603b5510794d1f8324cc0e201082b9fee838335431d78'
AND (
token = 'nCoSSDH/0MuV5lW6ekO94tgNmmU4BkV3ymaqwbaa/74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)