UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IrhgYJCWa3+mKvDCtmqxIi64OVvqVPORa9mz6d8tH6E='
WHERE
key_id = 'e1ca968c79a894876b909aa2edc04bbf664aaea0cdf4c4996fffa181ce6957af'
AND (
token = 'IrhgYJCWa3+mKvDCtmqxIi64OVvqVPORa9mz6d8tH6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)