UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1S53330rhuS75CaTmVhnPMhyHfOgk2bIf1jsUZLjiOI='
WHERE
key_id = 'ae0f5b9ad1547b15c7ef8528a74b7cce6e324ba3fa55cdad0384381735ebe79a'
AND (
token = '1S53330rhuS75CaTmVhnPMhyHfOgk2bIf1jsUZLjiOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)