UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4HU0AwzpRlIG6JBdAkrZCaJIo78kf9zqzg4RpNtOLc='
WHERE
key_id = '07a42f10a149c915ca4e18823074edd7b20793598f15acdea6e4360344b89e81'
AND (
token = 'a4HU0AwzpRlIG6JBdAkrZCaJIo78kf9zqzg4RpNtOLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)