UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QZfQPav+QYcaTpX/sGRSt5sS22sz7djuvfMlSSAHk0w='
WHERE
key_id = '08696c8cce5bd54ed45d0f820d50ef3b2d1cbd65c768c9464e38b6595ae18168'
AND (
token = 'QZfQPav+QYcaTpX/sGRSt5sS22sz7djuvfMlSSAHk0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)