UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZihNtXOIzD8AMrTMGksHrEKHg+1d7LkDJ6UvBnBGP5I='
WHERE
key_id = 'a4c1b6765bcf9ecc2deeb62096e60d302b57dc340d642340db81c35b9c00f808'
AND (
token = 'ZihNtXOIzD8AMrTMGksHrEKHg+1d7LkDJ6UvBnBGP5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)