UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8acr2oW1bb9tlcVUeWVyyT3Otrw1yOvq/pmmHy//emg='
WHERE
key_id = '500ae6c70d84de85a88a638f2a566790f1e5a764ab17a4cbc28f025841b50464'
AND (
token = '8acr2oW1bb9tlcVUeWVyyT3Otrw1yOvq/pmmHy//emg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)