UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oZMRKCbWWHgLXDbdTeUR99WcmnA/SCnkRnZCyra8WIA='
WHERE
key_id = 'cacaabddcedffd13a15848b26ee6986b712e842958db15be3b7549c2c3660b4f'
AND (
token = 'oZMRKCbWWHgLXDbdTeUR99WcmnA/SCnkRnZCyra8WIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)