UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fDWpY/K5oAEiezHWazpQ2TwZM7gj9XnDPVlklS6cggg='
WHERE
key_id = 'fd11853cd92d77ef0233101e48abed8d43eee489bb8039056c85cf8d35829144'
AND (
token = 'fDWpY/K5oAEiezHWazpQ2TwZM7gj9XnDPVlklS6cggg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)