UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AQv5O8zm9umosJ58DAC+PWQHkqNIBZJd7DgURSdeNX8='
WHERE
key_id = '48aa6bb0e3de76f2a1e90e0e1f37630c84e91b8e2a391c753577ff08bafb87f9'
AND (
token = 'AQv5O8zm9umosJ58DAC+PWQHkqNIBZJd7DgURSdeNX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)