UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b5VxSTS+EGsb4QHxLnDQQXn9OmsBnJW6xhicQYl1Dcw='
WHERE
key_id = 'a3fd1b7d19ed01c18f4b01b56045847b73e1b6f52644ad10fd0260b3a202118c'
AND (
token = 'b5VxSTS+EGsb4QHxLnDQQXn9OmsBnJW6xhicQYl1Dcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)