UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ehwCA+nNa70DmiM//3zW5J2rJIJt12Aq5GtQg43nGmw='
WHERE
key_id = 'caaa88ec2f090ab9f5043da0ca01d9191ebe0a8db142f8055e1752925a0eb2d7'
AND (
token = 'ehwCA+nNa70DmiM//3zW5J2rJIJt12Aq5GtQg43nGmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)