UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W3q/v3AnS9T/lTOXE+i0qYeTwpDTiifF4RqjD+Ae9CY='
WHERE
key_id = 'ee2c52ced6b15023d27612171c38ad6f28f5b65c12ee3055c6dceb66bfd1aefc'
AND (
token = 'W3q/v3AnS9T/lTOXE+i0qYeTwpDTiifF4RqjD+Ae9CY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)