UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vKiCZi8utkWdGBYu9Y0CrzdmcqenMFEGvF9339CVKLs='
WHERE
key_id = '147c2bc595922a512a5e55d76cb5849ba3e4d34895fce97ccb9c35f2b1a2e20f'
AND (
token = 'vKiCZi8utkWdGBYu9Y0CrzdmcqenMFEGvF9339CVKLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)