UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'clkAP3UjV1DXYPuB7uUjAkruyYwV2W8kYaw9JrKUZzU='
WHERE
key_id = '08a1f6d113938a4b6ce85038addd87abfc455050a393f7d009184ee7f92fe389'
AND (
token = 'clkAP3UjV1DXYPuB7uUjAkruyYwV2W8kYaw9JrKUZzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)