UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3KMcE8bVDJf88BLKlwMo12y9ekluCXeWg9nZmTFlRws='
WHERE
key_id = '8234fe776c8184c90fffe287a1b5723470c0ffcb5cbb6c6c5f5df5aa588be10d'
AND (
token = '3KMcE8bVDJf88BLKlwMo12y9ekluCXeWg9nZmTFlRws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)