UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MxlJ7xeq8Fg9CcI9OnW3nToDI/n8XpbgpG/XSadGmPg='
WHERE
key_id = 'e39184a4be9673f689f74fbc2c7983b89a84c725095bb7a381acd62c50163491'
AND (
token = 'MxlJ7xeq8Fg9CcI9OnW3nToDI/n8XpbgpG/XSadGmPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)