UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3hbA3dTbckJHNxrwrxsNSrCzdv78Fn4tLK8hoovGysY='
WHERE
key_id = '7d1e0e14e29f335ee370bde139a3a1edba74eed9b7bc117eb6b5cb503d544021'
AND (
token = '3hbA3dTbckJHNxrwrxsNSrCzdv78Fn4tLK8hoovGysY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)