UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rO/94lHVsXI1oAg/4lw4E4T7D/BB3TsBopcsUyGW30A='
WHERE
key_id = '7c780b96012201172b50b5f2acd9ecc57004241553afd4f6b348a6589b462034'
AND (
token = 'rO/94lHVsXI1oAg/4lw4E4T7D/BB3TsBopcsUyGW30A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)