UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PmacXzE5IKe21QRMm5iuTDUlLOjUJ2efsSWDHB7I7Bg='
WHERE
key_id = '720f50e91a0f0487bb67bc20f640deb8cfd1be051de7fa3ccfbd2c2ea3b2ee03'
AND (
token = 'PmacXzE5IKe21QRMm5iuTDUlLOjUJ2efsSWDHB7I7Bg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)