UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q7RsnUDeyf47CDsjy3WDgEZM/tYYDb3pII04ym7NM3o='
WHERE
key_id = '2250ff8ae524a6f2507a799d0e07a1fd35f4abab77ff9bfcc3da7f1ef43bc067'
AND (
token = 'Q7RsnUDeyf47CDsjy3WDgEZM/tYYDb3pII04ym7NM3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)