UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wuxG6yV87cwgKncwlFNfn6wjgYFSsEaVK7RBZpGWlm0='
WHERE
key_id = '6b607ca4def18b31a5fdd52bbb8b79a78e9e96ffa15ac6670a9194de838f27f4'
AND (
token = 'wuxG6yV87cwgKncwlFNfn6wjgYFSsEaVK7RBZpGWlm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)